SUBSTITUTE
Assume that you must write a formula for the B2 cell to get the result shown. Choose all valid formulas for the B2 cell from the list below.
=SUBSTITUTE(A2,B5,B4)
=SUBSTITUTE(A2,B4,B5)
=SUBSTITUTE($A2,$B4,$B5)
=SUBSTITUTE($A2,B5,B4)
=SUBSTITUTE(A2,$B$4,$B$5)
=SUBSTITUTE($A$2,$B$4,$B$5)
=SUBSTITUTE(A2,"will solve",B4)
=SUBSTITUTE(A2,"I will solve",B4)
Next Concept
